Deleting a user which has an unreviewed revision is going to delete the entire kb article if the first revision is unreviewed but belongs to a different user

[emilghittasv]

Preconditions
Sign in to SUMO with account A

Steps to reproduce
Steps to reproduce the behavior:

1. Go to https://support.allizom.org/en-US/kb/new
2. Create a new kb article and don't approve the first revision.
3. Sign in with a different user (User B) which has the necessary permissions to access an article which is not live yet.
4. Create a new revision to the article (do not approve it).
5. Delete the user from step 3.

Expected behavior
Only the unapproved revision from the deleted user is deleted. The unreviewed revision belonging to a different user should not be affected (deleted).

Actual behavior
Both revisions and the entire kb article is deleted.

Desktop:

• OS: Windows 11
• Browser: Firefox

Additional context
This issue is reproducible in stage.

[akatsoulas]

PR mozilla/kitsune#6577

[akatsoulas]

@escattone just an fyi in case this is also relevant to #2262

[emilghittasv]

I can confirm that this issue is verified fixed in stage.

I'm moving this ticket inside the release column.